{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["About Program Cost Recovery","A1. Program Details","A2. Estimated Expenses","A3. Estimated Income","A4. Estimated Summary","B1. Actual Program Details ","B2. Actual Expenses  ","B3. Actual Income","B4. Actual Summary"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":3,"comments":8,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"About Program Cost Recovery","index":0,"n_rows":19,"n_cols":2,"rows_kept":19,"cut":false,"hidden":false,"merged":[[10,1,10,14],[13,1,13,13],[5,1,6,14],[4,1,4,12],[8,1,8,12]]}
[]
[]
[null,"Welcome to the MSU Extension Events Financial Managment Worksheet.  This worksheet is divided into two components: "]
[]
[null,"Section A1 through A4 is used as a program budget planning tool. At the very least, expenses should equal program income so the program breaks-even and workgroup does not incur additional out of pocket expense not covered by the program."]
[null,"Use the first 4 sets of Excel worksheets (A1. Program Details, A2. Estimated Expenses, A3.Estimated  Income and A4. Estimated Summary) to estimate expenses for extension program or services AND hold the program or service."]
[]
[]
[null,"Section B1 through B4 is completed after program or service has been held. Workgroup can see a more realistic cost of program. Recovered program funds can be allocated according to agreed expense percentage incurred by each participating party. "]
[]
[null,"Use the next 4 sets of Excel worksheets (B1. Program Details, B2. Estimated Expenses, B3.Estimated  Income and B4. Estimated Summary) to estimate expenses for extension program or services AND hold the program or service."]
[]
[]
[null,"B worksheets are used after the completion of the program. The educator will use this set of worksheets to adjust for actual cost of holding the program. It allows for a more realistic cost of holding the program so the work team knows the exact cost of program including what the workgroup paid for, what the participant might have paid for, what amount a sponsor or grant may have contributed to the program, etc. This also allows the workgroup and its partners to recover any amount over breakeven and allocate the amount based on percentages contributed to the cost of the program."]
[]
[]
[]
[]
[null," "]

{"sheet":"A1. Program Details","index":1,"n_rows":51,"n_cols":8,"rows_kept":51,"cut":false,"hidden":false,"merged":[[20,2,20,6],[30,1,30,5],[2,1,2,8],[13,1,13,8],[15,2,15,6],[18,2,18,6],[4,1,4,2],[14,2,14,6],[6,1,11,8],[4,7,4,8],[4,4,4,5],[19,2,19,6],[21,2,21,6],[17,2,17,6],[16,2,16,6],[43,1,44,1],[43,5,44,5],[32,1,33,1],[32,2,32,3],[32,4,33,4],[32,5,33,5],[43,2,43,4]]}
[]
[]
[null,"Estimated Program Costs and Cost Recovery Worksheet  - use to estimate cost before holding event."]
[]
[null,"A2. Estimated Expenses",null,null,"A3. Estimated Income",null,null,"A4. Estimated Summary"]
[null,null,null," "]
[null,"Instructions: This spreadsheet has been created to help plan program expenses and income, and allow for returning cost recovery funds among the responsible parties. Different worksheets have been set up for program details, program estimated expenses, program estimated income, and program estimated summary page. Moving between the worksheets is possible using the links at the top of each page or the tabs at the bottom of the Excel workspace. \n\nComplete the workbook by filling in the blue highlighted fields. Other fields are meant to remain stable or include a formula to calculate values for you. A print button is included on the summary page, macros must be enabled for this option to work."]
[]
[]
[]
[]
[]
[]
[null,"Program Details"]
[null,"Program/Service:",null,null,null,null,null,"DATE:"]
[null,"Lead Person Name:"]
[null,"Lead Person - Phone Number:"]
[null,"Lead Person - Email Address:"]
[null,"Staff Member(s):"]
[null,"Partners/Client:"]
[null,"Desired Location/Facility: "]
[null,"Purpose of Program/Event:"]
[null,"Sessions (will the program repeat):"]
[null,"Estimated Number of Participants:"]
[null,"Event Level (Required): ",null,"This number activates the calculations throughout the remainder of the spreadsheet"]
[]
[null,"How many educators are involved?: ",null,"This number will determine the split at the end. "]
[null,"Which institute or College is involved?",null,"Please list the institute or college dept. for this project"]
[]
[]
[null,"Please complete the following information regarding personnel expenses, hours and travel, $ per hour is an organizational average. "]
[]
[null,"Personnel","Budgeted Hours",null,"Avg $ \nper Hr","Budgeted Salary"]
[null,null,"Teaching","Preparation"]
[null,"Educator",null,null,52.44,{"$f":"SUM((C35+D35)*E35)","v":0}]
[null,"Specialist",null,null,71.34,0]
[null,"Program Instructor",null,null,33.479999999999997,0]
[null,"Program Coordinator ",null,null,41.49,0]
[null,"PA, PI and PC",null,null,35,0]
[null,null,null,null,null,0]
[null," Total Personnel Salaries That Must be Recovered"," "," "," ",{"$f":"IF(C25=2,((F35+F36+F37+F39+F40)/2),IF(C25=3,(F35+F36+F37+F39+F40),\"0\"))","v":"0"}]
[null,null,null,null,null," "]
[]
[null,"Personnel","Budgeted Travel Costs",null,null,"Total Budgeted Travel Costs"]
[null,null,"Miles","IRS Rate","Meals/Parking"]
[null,null,null,0.76,null,{"$f":"(C46*D46)+E46","v":0}]
[null,null,null,0.76,null,{"$f":"(C47*D47)+E47","v":0}]
[null,null,null,0.76,null,{"$f":"(C48*D48)+E48","v":0}]
[null,null,null,0.76,null,{"$f":"(C49*D49)+E49","v":0}]
[null,null,null,0.76,null,{"$f":"(C50*D50)+E50","v":0}]
[null,"Total Personnel Travel That Must be Recovered",{"$f":"SUM(C46:C50)","v":0},null,0,{"$f":"SUM(F46:F50)","v":0}]

{"sheet":"A2. Estimated Expenses","index":2,"n_rows":62,"n_cols":24,"rows_kept":62,"cut":false,"hidden":false,"merged":[[37,1,37,6],[10,1,10,6],[6,1,8,6],[17,2,17,4],[13,2,13,4],[12,2,12,4],[14,2,14,4],[15,2,15,4],[16,2,16,4],[45,2,45,4],[4,3,4,5],[4,6,4,8],[35,2,35,4],[23,2,23,4],[21,2,21,4],[22,2,22,4],[34,2,34,4],[30,2,30,4],[33,2,33,4],[32,2,32,4],[18,2,18,4],[19,2,19,4],[20,2,20,4],[42,2,42,4],[43,2,43,4],[46,2,46,4],[2,1,2,6],[62,6,62,7],[41,2,41,4],[40,2,40,4],[24,2,24,4],[25,2,25,4],[39,2,39,4],[31,2,31,4],[26,2,26,4],[53,1,53,6],[29,2,29,4],[47,2,47,4],[49,2,49,4],[44,2,44,4],[36,2,36,4]]}
[]
[]
[null,{"$f":"\"Estimated Expenses for \"&('A1. Program Details'!$C$15)&\"\"","v":"Estimated Expenses for "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[null,"A1. Program Details",null,"A3. Estimated Income",null,null,"A4. Estimated Summary"]
[]
[null,"Instructions:  This worksheet allows you to calculate estimated expenses for a program/service/event. To complete, enter values in the blue highlighted fields. Non-shaded cells are meant to remain stable or contain a formula to calculate values for you. Check the option box to the right to show details for expenses. The details will automatically calculate. To view other worksheets, use the links above or tabs at the bottom of the workspace."]
[]
[]
[]
[null,"Program/Service Expenses"]
[null,"Program Variable Cost/participant","Notes",null,null,"Cost/Person","Budget"]
[null,"Meals, refreshments (/person/session)"," ",null,null,null,{"$f":"F13*'A1. Program Details'!$C$24","v":0}]
[null,null,null,null,null,null,{"$f":"F14*'A1. Program Details'!$C$24","v":0}]
[null,null,null,null,null,null,{"$f":"F15*'A1. Program Details'!$C$24","v":0}]
[null,null,null,null,null,null,{"$f":"F16*'A1. Program Details'!$C$24","v":0}]
[null,null,null,null,null,null,{"$f":"F17*'A1. Program Details'!$C$24","v":0}]
[null,null,null,null,null,null,{"$f":"F18*'A1. Program Details'!$C$24","v":0}]
[null,null,null,null,null,null,{"$f":"F19*'A1. Program Details'!$C$24","v":0}]
[null,null,null,null,null,null,{"$f":"F20*'A1. Program Details'!$C$24","v":0}]
[null,null,null,null,null,null,{"$f":"F21*'A1. Program Details'!$C$24","v":0}]
[null,null,null,null,null,null,{"$f":"F22*'A1. Program Details'!$C$24","v":0}]
[null,null,null,null,null,null,{"$f":"F23*'A1. Program Details'!$C$24","v":0}]
[null,null,null,null,null,null,{"$f":"F24*'A1. Program Details'!$C$24","v":0}]
[null,null,null,null,null,null,{"$f":"F25*'A1. Program Details'!$C$24","v":0}]
[null,null,null,null,null,null,{"$f":"F26*'A1. Program Details'!$C$24","v":0}]
[" ","     Subtotal for variable costs",null,null,null,null,{"$f":"SUM(G13:G26)","v":0}]
[]
[null,"Program Fixed Cost - Taxable","Notes",null,null,"Cost","Budget"]
[null,null,null,null,null,null,{"$f":"F30*'A1. Program Details'!$C$23","v":0}]
[null,null,null,null,null,null,{"$f":"F31*'A1. Program Details'!$C$23","v":0}]
[null,null,null,null,null,null,{"$f":"F32*'A1. Program Details'!$C$23","v":0}]
[null,null,null,null,null,null,{"$f":"F33*'A1. Program Details'!$C$23","v":0}]
[null,null,null,null,null,null,{"$f":"F34*'A1. Program Details'!$C$23","v":0}]
[null,null,null,null,null,null,{"$f":"F35*'A1. Program Details'!$C$23","v":0}]
[null,null,null,null,null,null,{"$f":"F36*'A1. Program Details'!$C$23","v":0}]
[null,null,null,null,null,null,{"$f":"F37*'A1. Program Details'!$C$23","v":0}]
[]
[null,"Program Fixed Cost - Non Taxable","Notes",null,null,"Cost","Budget"]
[null,null,null,null,null,null,{"$f":"F40*'A1. Program Details'!$C$23","v":0}]
[null,null,null,null,null,null,{"$f":"F41*'A1. Program Details'!$C$23","v":0}]
[null,null,null,null,null,null,{"$f":"F42*'A1. Program Details'!$C$23","v":0}]
[null,null,null,null,null,null,{"$f":"F43*'A1. Program Details'!$C$23","v":0}]
[null,null,null,null,null,null,{"$f":"F44*'A1. Program Details'!$C$23","v":0}]
[null,null,null,null,null,null,{"$f":"F45*'A1. Program Details'!$C$23","v":0}]
[null,"Subtotal for fixed expenses",null,null,null,null,{"$f":"(SUM(G30:G37))+(SUM(G40:G45))","v":0}]
[null,"ANR Event Services Planning Fee","dependent upon level of service needed",null,null,null,{"$f":"F47","v":0}]
[null,"Administrative Fees/ Credit Card Fees","cost of university fee on income  and credit card charges",null,null,0.06,{"$f":"('A3. Estimated Income'!G19+'A3. Estimated Income'!G30)*0.06","v":0}]
[null,"Sales Tax",null,null,null,0.06,{"$f":"(G27+(SUM(G30:G37)))*0.06","v":0}]
[null,"       Total costs",null,null,null,null,{"$f":"G27+G46+G47+G48+G49","v":0}]
[null,null,null,null,null,null,null,null," "]
[]
[]
[null,"Summary of Personnel and Travel Costs (For Level 2 and 3 Events Only). Please note - level 2 programs recovers 50% of salary total salary/benefits while level 3 programs recovers 100% of salary/benefits."]
[null,null,null,null,null,null,"Budget"]
[null,"Personnel Salary/Benefits",null,null,null,null,{"$f":"IF('A1. Program Details'!C25>1,'A1. Program Details'!F41,\"\")","v":""}]
[null,"Personnel Travel",null,null,null,null,{"$f":"'A1. Program Details'!F51","v":0}]
[null," Personnel/Travel Expenses",null,null,null,null,{"$f":"SUM(G56:G57)","v":0}]
[]
[]
[]
[null,"Total Program/Service Expenses",null,null,null,null,{"$f":"G50+G58","v":0}]

{"sheet":"A3. Estimated Income","index":3,"n_rows":37,"n_cols":7,"rows_kept":37,"cut":false,"hidden":false,"merged":[[2,1,2,6],[25,4,25,5],[26,2,26,3],[27,2,27,3],[21,4,21,5],[22,4,22,5],[23,4,23,5],[24,4,24,5],[21,2,21,3],[22,2,22,3],[23,2,23,3],[24,2,24,3],[36,1,36,5],[12,1,12,3],[4,3,4,4],[4,5,4,6],[4,7,4,8],[12,8,12,13],[11,1,11,3],[7,1,9,6],[32,1,32,5],[34,1,34,5],[29,2,29,3],[29,4,29,5],[25,2,25,3],[28,2,28,3],[28,4,28,5]]}
[]
[]
[null,{"$f":"\"Estimated Income for \"&('A1. Program Details'!$C$15)&\"\"","v":"Estimated Income for "}]
[]
[null,"A1. Program Details",null,"A2. Estimated Expenses",null,"A4. Estimated Summary"]
[]
[]
[null,"Instructions:  This worksheet is used to calculate estimated program income. Enter estimated participants fee as well as any sponsors or partner contributions/grants.  "]
[]
[]
[]
[null,"Registration fees/participant income",null,null,"Estimated number of participants","Estimated fee per person","Budgeted income"]
[null,"Registration fees  ",null,null,{"$f":"'A1. Program Details'!C24","v":0}," "," "]
[null,"   Early Registration",null,null,null,null,{"$f":"E14*F14","v":0}]
[null,"   Normal Registration",null,null,null,null,{"$f":"E15*F15","v":0}]
[null,"   Onsite Registration",null,null,null,null,0]
[null,"   Student Registration",null,null,null,null,0]
[]
[null,"Total registration income",null,null,null,null,{"$f":"SUM(G13:G18)","v":0}]
[]
[]
[null,"Sponsorship/grant/donation/other incoming funds to offset expenses","Sponsor/partner name",null,"Indicate if sponsorship, donation or in-kind?",null,"Amount"]
[null,"Sponsor"]
[null,"Sponsor"]
[null,"Other Funds"]
[null,"Other Funds"]
[null,"Other Funds"]
[null,"Other Funds"]
[null,"Other donation"]
[null,"Total sponsorship/grant/donation",null,null," ",null,{"$f":"SUM(G23:G29)","v":0}]
[]
[]
[null,"Total Program Income",null,null,null,null,{"$f":"G19","v":0}]
[]
[null,"Total Sponsorships",null,null,null,null,{"$f":"G30","v":0}]
[]
[null,"Gross Income",null,null,null,null,{"$f":"G33+G35","v":0}]

{"sheet":"A4. Estimated Summary","index":4,"n_rows":59,"n_cols":10,"rows_kept":59,"cut":false,"hidden":false,"merged":[[23,1,23,3],[43,2,44,6],[30,1,30,4],[2,1,2,6],[21,1,21,3],[13,1,13,3],[14,1,14,3],[12,1,12,3],[17,1,17,3],[7,1,7,6],[5,4,5,5],[5,2,5,3],[5,6,5,7],[15,1,15,3],[19,1,19,3],[18,1,18,3],[46,2,47,6],[49,2,50,6],[43,1,44,1],[45,1,50,1],[25,1,25,3],[26,1,26,3],[31,2,31,4]]}
[null," "]
[]
[null,{"$f":"\"Estimated Summary for \"&('A1. Program Details'!$C$15)&\"\"","v":"Estimated Summary for "}]
[]
[]
[null,"A1. Program Details","A2. Estimated Expenses",null,"A3. Estimated Income"]
[]
[null,"Instructions:  This page summarizes estimated income and expenses for the program/service. "]
[]
[null,"Income ",null,null,"Budgeted"]
[null,"Income from participant fees",null,null,{"$f":"'A3. Estimated Income'!G33","v":0}]
[]
[null,"Expense (broken down by cost per Participant)",null,null,"Budgeted"]
[null,"Variable Cost  ",null,null,{"$f":"IF('A1. Program Details'!C24>0,'A2. Estimated Expenses'!G27/'A1. Program Details'!C24)","v":false}]
[null,"Fixed Cost ",null,null,{"$f":"IF('A1. Program Details'!C24>0,'A2. Estimated Expenses'!G46/'A1. Program Details'!C24)","v":false}]
[null,"Event management fee, Admin & Credit Card Fees ",null,null,{"$f":"IF('A1. Program Details'!C24>0,('A2. Estimated Expenses'!G47+'A2. Estimated Expenses'!G48)/'A1. Program Details'!C24)","v":false}," "]
[null,"Sales Tax ",null,null,{"$f":"IF('A1. Program Details'!C24>0,('A2. Estimated Expenses'!G49)/'A1. Program Details'!C24)","v":false}]
[null,"Program related personnel and travel",null,null,{"$f":"IF('A1. Program Details'!C24>0,'A2. Estimated Expenses'!G58/'A1. Program Details'!C24)","v":false}," "]
[null,"Total cost per participant",null,null,{"$f":"IF('A1. Program Details'!C24>0,'A2. Estimated Expenses'!G62/'A1. Program Details'!C24)","v":false}," "," "," "," "," "]
[null,"Total expense of running program",null,null,{"$f":"E19*'A1. Program Details'!C24","v":0}]
[]
[null,"Net Income (not including sponsorships)",null,null,{"$f":"E11-E20","v":0}]
[]
[null,"Sponsorship/donation/grant given to program/service",null,null,{"$f":"'A3. Estimated Income'!G30","v":0}]
[]
[null,"Net Profit / (Loss)Total cost",null,null,{"$f":"E11+E24-E20","v":0}]
[null,"Net Profit / (Loss) per Participant ",null,null,{"$f":"E26/'A1. Program Details'!C24","v":{"$error":"#DIV/0!"}}]
[]
[null,"Taxable Amount per Person (For Events Management System)",null,null,{"$f":"IF('A1. Program Details'!C24>0,('A2. Estimated Expenses'!G27+'A2. Estimated Expenses'!G30+'A2. Estimated Expenses'!G31+'A2. Estimated Expenses'!G32+'A2. Estimated Expenses'!G33+'A2. Estimated Expenses'!G34+'A2. Estimated Expenses'!G35+'A2. Estimated Expenses'!G36+'A2. Estimated Expenses'!G37)/'A1. Program Details'!C24)","v":false}]
[]
[null,"Cost Recovery - This portion is required. "]
[null,"Contact for the Financial Aspects for the Event:"]
[null,"Option 1 - Groups","Amount ","Acct Number","Name"]
[null,"Work Group (50 percent)",{"$f":"IF('A1. Program Details'!C27>1,'A4. Estimated Summary'!E26*0.5,0)","v":0}]
[null,"Institute (50 percent)",{"$f":"IF('A1. Program Details'!C27>1,'A4. Estimated Summary'!E26*0.5,0)","v":0}]
[]
[null,"Option 2 - Individual","Amount ","Acct Number","Name"]
[null,"Work Group (30 percent)",{"$f":"IF('A1. Program Details'!C27=1,'A4. Estimated Summary'!E26*0.3,0)","v":0}]
[null,"Institute (30 percent)",{"$f":"IF('A1. Program Details'!C27=1,'A4. Estimated Summary'!E26*0.3,0)","v":0}]
[null,"Individual (40 percent)",{"$f":"IF('A1. Program Details'!C27=1,'A4. Estimated Summary'!E26*0.4,0)","v":0}]
[null,"MSU Extension Programs deviating from Option 1 or Option 2 must submit Institute Director approval prior to activation. "]
[]
[]
[null,"Signatures:"]
[null,null,null,null,null,null,null,"Work Group Leader"]
[null,"Institute Director signatures are required only if the sheet estimates your program will be operating at a loss. "]
[]
[null,null,null,null,null,null,null,"Institute Director"]
[]
[]
[null,null,null,null,null,null,null,"MSUE Director's Office"]
[]
[]
[]
[]
[]
[]
[]
[null,null," "]

{"sheet":"B1. Actual Program Details ","index":5,"n_rows":56,"n_cols":10,"rows_kept":56,"cut":false,"hidden":false,"merged":[[44,9,45,9],[21,2,21,6],[44,1,45,1],[44,2,44,4],[44,5,45,5],[44,6,44,8],[33,1,34,1],[33,2,33,3],[33,4,34,4],[33,5,34,5],[33,6,33,7],[33,8,34,8],[31,1,31,8],[20,2,20,6],[2,1,2,8],[4,1,4,2],[6,1,11,8],[13,1,13,8],[14,2,14,6],[15,2,15,6],[16,2,16,6],[4,3,4,5],[4,6,4,7],[19,2,19,6],[17,2,17,6]]}
[]
[]
[null,"Actual Program Costs and Revenue Generation Worksheet"]
[]
[null,"B2. Actual Expenses",null,"B3. Actual Income",null,null,"B4. Actual Summary"]
[]
[null,"Instructions: This spreadsheet is to be completed after program or serve has been held. Enter actual number of participants and adjust personnel expenses if changed after program was held. \n\nComplete the workbook by filling in the blue highlighted fields. Other fields are meant to remain stable or include a formula to calculate values for you. A print button is included on the summary page, macros must be enabled for this option to work."]
[]
[]
[]
[]
[]
[]
[null,"Program Details"]
[null,"Program/Service:",{"$f":"+'A1. Program Details'!C15:G15","v":0},null,null,null,null,"DATE:"]
[null,"Lead Person Name:",{"$f":"'A1. Program Details'!C16:G16","v":0}]
[null,"Lead Person - Phone Number:",{"$f":"'A1. Program Details'!C17:G17","v":0}]
[null,"Lead Person - Email Address:",{"$f":"'A1. Program Details'!C18:G18","v":0}]
[null,"Staff Member(s):",{"$f":"'A1. Program Details'!C19:G19","v":0}]
[null,"Partners/Client:",{"$f":"+'A1. Program Details'!C20:I20","v":0}]
[null,"Desired Location/Facility: ",{"$f":"'A1. Program Details'!C21:G21","v":0}]
[null,"Purpose of Program/Event:",{"$f":"+'A1. Program Details'!C22:I22","v":0}]
[null,"Sessions:",{"$f":"+'A1. Program Details'!C23","v":0},{"$f":"IF(C23=0,\"Number of sessions required for summary page to calculate correctly.\",\"\")","v":"Number of sessions required for summary page to calculate correctly."}]
[null,"Estimated Number of Participants:",{"$f":"+'A1. Program Details'!C24","v":0},{"$f":"IF(C24=0,\"Estimated number of participants required for summary page to calculate correctly.\",\"\")","v":"Estimated number of participants required for summary page to calculate correctly."}]
[null,"Actual Number of Participants:",null,{"$f":"IF(C25=0,\"Actual number of participants required for summary page to calculate correctly.\",\"\")","v":"Actual number of participants required for summary page to calculate correctly."}]
[null,"Event Level: ",{"$f":"+'A1. Program Details'!C25","v":0}," "]
[]
[null,"How many educators are involved?: ",{"$f":"'A1. Program Details'!C27","v":0}]
[null,"Which institute or College is involved?",{"$f":"'A1. Program Details'!C28","v":0}]
[]
[]
[null,"Please complete the following information regarding ACTUAL personnel expenses, including salaries and travel. "]
[null,null,null,null,null,null,null,null,null," "]
[null,"Personnel","Total Budgeted Hours",null,"Avg $ \nper Hr","Budgeted Salary","Actual Hours",null,"Actual  Salary"]
[null,null,"Teaching","Preparation",null,null,"Teaching","Preparation"]
[null,{"$f":"'A1. Program Details'!B35","v":"Educator"},{"$f":"+'A1. Program Details'!C35","v":0},{"$f":"+'A1. Program Details'!D35","v":0},{"$f":"'A1. Program Details'!E35","v":52.44},{"$f":"SUM((C36+D36)*E36)","v":0},null,null,{"$f":"SUM((G36+H36)*E36)","v":0}]
[null,{"$f":"'A1. Program Details'!B36","v":"Specialist"},{"$f":"+'A1. Program Details'!C36","v":0},{"$f":"+'A1. Program Details'!D36","v":0},{"$f":"'A1. Program Details'!E36","v":71.34},0,null,null,{"$f":"SUM((G37+H37)*E37)","v":0}]
[null,{"$f":"'A1. Program Details'!B37","v":"Program Instructor"},{"$f":"+'A1. Program Details'!C37","v":0},{"$f":"+'A1. Program Details'!D37","v":0},{"$f":"'A1. Program Details'!E37","v":33.479999999999997},0,null,null,0]
[null,{"$f":"'A1. Program Details'!B38","v":"Program Coordinator "},{"$f":"+'A1. Program Details'!C38","v":0},{"$f":"+'A1. Program Details'!D38","v":0},{"$f":"'A1. Program Details'!E38","v":41.49},0,null,null,{"$f":"SUM((G39+H39)*E39)","v":0}]
[null,{"$f":"'A1. Program Details'!B39","v":"PA, PI and PC"},{"$f":"+'A1. Program Details'!C39","v":0},{"$f":"+'A1. Program Details'!D39","v":0},{"$f":"'A1. Program Details'!E39","v":35},0,null,null,0]
[null,{"$f":"'A1. Program Details'!B40","v":0},{"$f":"+'A1. Program Details'!C40","v":0},{"$f":"+'A1. Program Details'!D40","v":0},{"$f":"'A1. Program Details'!E40","v":0},0,null,null,0]
[null," Total Personnel Salaries",{"$f":"SUM(C36:C41)","v":0},{"$f":"SUM(D36:D41)","v":0}," ",{"$f":"IF(C26=2,((F41+F36+F37+F38)/2),IF(C26=3,(F38+F36+F37+F41),\"0\"))","v":"0"},{"$f":"SUM(G36:G41)","v":0},{"$f":"SUM(H36:H41)","v":0},{"$f":"IF(C26=2,((I36+I37+I38+I40+I41)/2),IF(C26=3,(I36+I37+I38+I39+I40+I41),\"0\"))","v":"0"}," "]
[]
[]
[null,"Personnel","Budgeted Travel Costs",null,null,"Total Budgeted Travel Costs","Actual Travel Costs",null,null,"Total Actual Travel Costs"]
[null,null,"Miles","IRS Rate","Meals/Parking",null,"Miles","IRS Rate","Meals/Parking"]
[null,{"$f":"'A1. Program Details'!B46","v":0},{"$f":"+'A1. Program Details'!C46","v":0},{"$f":"'A1. Program Details'!D46","v":0.76},{"$f":"+'A1. Program Details'!E46","v":0},{"$f":"(C47*D47)+E47","v":0},null,{"$f":"D47","v":0.76},null,{"$f":"(G47*H47)+I47","v":0}]
[null,{"$f":"'A1. Program Details'!B47","v":0},{"$f":"+'A1. Program Details'!C47","v":0},{"$f":"'A1. Program Details'!D47","v":0.76},{"$f":"+'A1. Program Details'!E47","v":0},{"$f":"(C48*D48)+E48","v":0},null,{"$f":"D48","v":0.76},null,{"$f":"(G48*H48)+I48","v":0}]
[null,{"$f":"'A1. Program Details'!B48","v":0},{"$f":"+'A1. Program Details'!C48","v":0},{"$f":"'A1. Program Details'!D48","v":0.76},{"$f":"+'A1. Program Details'!E48","v":0},0,null,0.76,null,{"$f":"(G49*H49)+I49","v":0}]
[null,{"$f":"'A1. Program Details'!B49","v":0},{"$f":"+'A1. Program Details'!C49","v":0},{"$f":"'A1. Program Details'!D49","v":0.76},{"$f":"+'A1. Program Details'!E49","v":0},0,null,0.76,null,0]
[null,{"$f":"+'A1. Program Details'!B50","v":0},{"$f":"+'A1. Program Details'!C50","v":0},{"$f":"'A1. Program Details'!D50","v":0.76},{"$f":"+'A1. Program Details'!E50","v":0},0,null,0.76,null,0]
[null,"Total Personnel Travel ",{"$f":"SUM(C47:C51)","v":0},null,0,{"$f":"SUM(F47:F51)","v":0},{"$f":"SUM(G47:G51)","v":0},null,{"$f":"SUM(I47:I51)","v":0},{"$f":"SUM(J47:J51)","v":0}]
[]
[]
[]
[null,null,null,null," "]

{"sheet":"B2. Actual Expenses  ","index":6,"n_rows":79,"n_cols":11,"rows_kept":79,"cut":false,"hidden":false,"merged":[[43,1,43,8],[40,2,40,4],[41,2,41,4],[42,2,42,4],[69,6,69,7],[58,2,58,4],[62,1,62,9],[55,2,55,4],[69,1,69,2],[49,2,49,4],[50,2,50,4],[54,2,54,4],[46,2,46,4],[47,2,47,4],[48,2,48,4],[53,2,53,4],[25,2,25,4],[17,2,17,4],[21,2,21,4],[22,2,22,4],[24,2,24,4],[18,2,18,4],[19,2,19,4],[20,2,20,4],[23,2,23,4],[12,2,12,4],[13,2,13,4],[14,2,14,4],[15,2,15,4],[16,2,16,4],[10,1,10,10],[2,1,2,10],[4,1,4,2],[6,1,8,10],[4,3,4,5],[4,6,4,9],[26,2,26,4],[27,2,27,4],[28,2,28,4],[51,2,51,4],[52,2,52,4],[38,2,38,4],[29,2,29,4],[33,2,33,4],[34,2,34,4],[37,2,37,4],[32,2,32,4],[35,2,35,4],[36,2,36,4],[39,2,39,4],[44,2,44,4],[45,2,45,4]]}
[]
[]
[null,{"$f":"\"Actual Expenses for \"&('A1. Program Details'!$C$15)&\"\"","v":"Actual Expenses for "}]
[]
[null,"B1. Actual Program Details",null,"B3. Actual Income",null,null,"B4. Actual Summary"]
[]
[null,"Instructions:  This worksheet allows you to calculate expenses for a program/service. To complete, enter values in the blue highlighted fields. Non-shaded cells are meant to remain stable or contain a formula to calculate values for you. Check the option box to the right to show details for expenses. The details will automatically calculate. To view other worksheets, use the links above or tabs at the bottom of the workspace."]
[]
[]
[]
[null,"Program/Service Expenses"]
[null,"Program Variable Cost/participant","Notes",null,null,"Cost/Person","Budget","Act. Cost/\nPerson","Total Actual\nCost"]
[null,"Meals, refreshments (/person/session)"," ",null,null,null,{"$f":"F13*'A1. Program Details'!$C$24","v":0},null,{"$f":"H13*'B1. Actual Program Details '!C25","v":0}]
[{"$f":"+'A2. Estimated Expenses'!14:14","v":0},{"$f":"+'A2. Estimated Expenses'!B14","v":0},{"$f":"+'A2. Estimated Expenses'!C14:E14","v":0},null,null,{"$f":"+'A2. Estimated Expenses'!F14","v":0},{"$f":"F14*'A1. Program Details'!$C$24","v":0},null,{"$f":"H14*'B1. Actual Program Details '!C25","v":0}]
[null,{"$f":"+'A2. Estimated Expenses'!B15","v":0},{"$f":"+'A2. Estimated Expenses'!C15:E15","v":0},null,null,{"$f":"+'A2. Estimated Expenses'!F15","v":0},{"$f":"F15*'A1. Program Details'!$C$24","v":0},null,{"$f":"H15*'B1. Actual Program Details '!C25","v":0}]
[null,{"$f":"+'A2. Estimated Expenses'!B16","v":0},{"$f":"+'A2. Estimated Expenses'!C16:E16","v":0},null,null,{"$f":"+'A2. Estimated Expenses'!F16","v":0},{"$f":"F16*'A1. Program Details'!$C$24","v":0},null,{"$f":"H16*'B1. Actual Program Details '!C25","v":0}]
[null,{"$f":"+'A2. Estimated Expenses'!B17","v":0},{"$f":"+'A2. Estimated Expenses'!C17:E17","v":0},null,null,{"$f":"+'A2. Estimated Expenses'!F17","v":0},{"$f":"F17*'A1. Program Details'!$C$24","v":0},null,{"$f":"H17*'B1. Actual Program Details '!C25","v":0}]
[null,{"$f":"+'A2. Estimated Expenses'!B18","v":0},{"$f":"+'A2. Estimated Expenses'!C18:E18","v":0},null,null,{"$f":"+'A2. Estimated Expenses'!F18","v":0},{"$f":"F18*'A1. Program Details'!$C$24","v":0},null,{"$f":"H18*'B1. Actual Program Details '!C25","v":0}]
[null,{"$f":"+'A2. Estimated Expenses'!B19","v":0},{"$f":"+'A2. Estimated Expenses'!C19:E19","v":0},null,null,{"$f":"+'A2. Estimated Expenses'!F19","v":0},{"$f":"F19*'A1. Program Details'!$C$24","v":0},null,{"$f":"H19*'B1. Actual Program Details '!C25","v":0}]
[null,{"$f":"+'A2. Estimated Expenses'!B20","v":0},{"$f":"+'A2. Estimated Expenses'!C20:E20","v":0},null,null,{"$f":"+'A2. Estimated Expenses'!F20","v":0},{"$f":"F20*'A1. Program Details'!$C$24","v":0},null,{"$f":"H20*'B1. Actual Program Details '!C25","v":0}]
[null,{"$f":"+'A2. Estimated Expenses'!B21","v":0},{"$f":"+'A2. Estimated Expenses'!C21:E21","v":0},null,null,{"$f":"+'A2. Estimated Expenses'!F21","v":0},{"$f":"F21*'A1. Program Details'!$C$24","v":0},null,{"$f":"H21*'B1. Actual Program Details '!C25","v":0}]
[null,{"$f":"+'A2. Estimated Expenses'!B22","v":0},{"$f":"+'A2. Estimated Expenses'!C22:E22","v":0},null,null,{"$f":"+'A2. Estimated Expenses'!F22","v":0},{"$f":"F22*'A1. Program Details'!$C$24","v":0},null,{"$f":"H22*'B1. Actual Program Details '!C25","v":0}]
[null,{"$f":"+'A2. Estimated Expenses'!B23","v":0},{"$f":"+'A2. Estimated Expenses'!C23:E23","v":0},null,null,{"$f":"+'A2. Estimated Expenses'!F23","v":0},{"$f":"F23*'A1. Program Details'!$C$24","v":0},null,{"$f":"H23*'B1. Actual Program Details '!C25","v":0}]
[null,{"$f":"+'A2. Estimated Expenses'!B24","v":0},{"$f":"+'A2. Estimated Expenses'!C24:E24","v":0},null,null,{"$f":"+'A2. Estimated Expenses'!F24","v":0},{"$f":"F24*'A1. Program Details'!$C$24","v":0},null,{"$f":"H24*'B1. Actual Program Details '!C25","v":0}]
[null,{"$f":"+'A2. Estimated Expenses'!B25","v":0},{"$f":"+'A2. Estimated Expenses'!C25:E25","v":0},null,null,{"$f":"+'A2. Estimated Expenses'!F25","v":0},{"$f":"F25*'A1. Program Details'!$C$24","v":0},null,{"$f":"H25*'B1. Actual Program Details '!C25","v":0}]
[null,{"$f":"+'A2. Estimated Expenses'!B26","v":0},{"$f":"+'A2. Estimated Expenses'!C26:E26","v":0},null,null,{"$f":"+'A2. Estimated Expenses'!F26","v":0},{"$f":"F26*'A1. Program Details'!$C$24","v":0},null,{"$f":"H26*'B1. Actual Program Details '!C25","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"H27*'B1. Actual Program Details '!C25","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"H28*'B1. Actual Program Details '!C25","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"H29*'B1. Actual Program Details '!C25","v":0}]
[" ","     Subtotal for variable costs",null,null,null,null,{"$f":"SUM(G13:G26)","v":0},{"$f":"SUM(H13:H29)","v":0},{"$f":"SUM(I13:I29)","v":0}]
[]
[null,"Program Fixed Cost - Taxable","Notes",null,null,"Cost","Budget","Act. Cost","Total Actual\nCost Across All Sessions"]
[null,{"$f":"+'A2. Estimated Expenses'!B30","v":0},{"$f":"+'A2. Estimated Expenses'!C30:E30","v":0},null,null,{"$f":"+'A2. Estimated Expenses'!F30","v":0},{"$f":"F33","v":0},null,{"$f":"H33*'B1. Actual Program Details '!C23","v":0}]
[null,{"$f":"+'A2. Estimated Expenses'!B31","v":0},{"$f":"+'A2. Estimated Expenses'!C31:E31","v":0},null,null,{"$f":"+'A2. Estimated Expenses'!F31","v":0},0,null,{"$f":"H34*'B1. Actual Program Details '!C23","v":0}]
[null,{"$f":"+'A2. Estimated Expenses'!B32","v":0},{"$f":"+'A2. Estimated Expenses'!C32:E32","v":0},null,null,{"$f":"+'A2. Estimated Expenses'!F32","v":0},0,null,{"$f":"H35*'B1. Actual Program Details '!C23","v":0}]
[null,{"$f":"+'A2. Estimated Expenses'!B33","v":0},{"$f":"+'A2. Estimated Expenses'!C33:E33","v":0},null,null,{"$f":"+'A2. Estimated Expenses'!F33","v":0},0,null,{"$f":"H36*'B1. Actual Program Details '!C23","v":0}]
[null,{"$f":"+'A2. Estimated Expenses'!B34","v":0},{"$f":"+'A2. Estimated Expenses'!C34:E34","v":0},null,null,{"$f":"+'A2. Estimated Expenses'!F34","v":0},0,null,{"$f":"H37*'B1. Actual Program Details '!C23","v":0}]
[null,{"$f":"+'A2. Estimated Expenses'!B35","v":0},{"$f":"+'A2. Estimated Expenses'!C35:E35","v":0},null,null,{"$f":"+'A2. Estimated Expenses'!F35","v":0},0,null,{"$f":"H38*'B1. Actual Program Details '!C23","v":0}]
[null,{"$f":"+'A2. Estimated Expenses'!B36","v":0},{"$f":"+'A2. Estimated Expenses'!C36:E36","v":0},null,null,{"$f":"+'A2. Estimated Expenses'!F36","v":0},0,null,{"$f":"H39*'B1. Actual Program Details '!C23","v":0}]
[null,{"$f":"+'A2. Estimated Expenses'!B37","v":0},{"$f":"+'A2. Estimated Expenses'!C37:E37","v":0},null,null,{"$f":"+'A2. Estimated Expenses'!F37","v":0},0,null,{"$f":"H40*'B1. Actual Program Details '!C23","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"H41*'B1. Actual Program Details '!C26","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"H42*'B1. Actual Program Details '!C26","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"H43*'B1. Actual Program Details '!C26","v":0}]
[]
[null,{"$f":"+'A2. Estimated Expenses'!B39","v":"Program Fixed Cost - Non Taxable"},{"$f":"+'A2. Estimated Expenses'!C39:E39","v":"Notes"},null,null,{"$f":"+'A2. Estimated Expenses'!F39","v":"Cost"},"Cost","Act. Cost","Total Actual Cost Across "]
[null,{"$f":"+'A2. Estimated Expenses'!B40","v":0},{"$f":"+'A2. Estimated Expenses'!C40:E40","v":0},null,null,{"$f":"+'A2. Estimated Expenses'!F40","v":0},0,null,{"$f":"H46*'B1. Actual Program Details '!C23","v":0}]
[null,{"$f":"+'A2. Estimated Expenses'!B41","v":0},{"$f":"+'A2. Estimated Expenses'!C41:E41","v":0},null,null,{"$f":"+'A2. Estimated Expenses'!F41","v":0},0,null,{"$f":"H47*'B1. Actual Program Details '!C23","v":0}]
[null,{"$f":"+'A2. Estimated Expenses'!B42","v":0},{"$f":"+'A2. Estimated Expenses'!C42:E42","v":0},null,null,{"$f":"+'A2. Estimated Expenses'!F42","v":0},0,null,{"$f":"H48*'B1. Actual Program Details '!C23","v":0}]
[null,{"$f":"+'A2. Estimated Expenses'!B43","v":0},{"$f":"+'A2. Estimated Expenses'!C43:E43","v":0},null,null,{"$f":"+'A2. Estimated Expenses'!F43","v":0},0,null,{"$f":"H49*'B1. Actual Program Details '!C23","v":0}]
[null,{"$f":"+'A2. Estimated Expenses'!B44","v":0},{"$f":"+'A2. Estimated Expenses'!C44:E44","v":0},null,null,{"$f":"+'A2. Estimated Expenses'!F44","v":0},0,null,{"$f":"H50*'B1. Actual Program Details '!C23","v":0}]
[null,{"$f":"+'A2. Estimated Expenses'!B45","v":0},{"$f":"+'A2. Estimated Expenses'!C45:E45","v":0},null,null,{"$f":"+'A2. Estimated Expenses'!F45","v":0},0,null,{"$f":"H51*'B1. Actual Program Details '!C23","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"H52*'B1. Actual Program Details '!C23","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"H53*'B1. Actual Program Details '!C23","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"H54*'B1. Actual Program Details '!C23","v":0}]
[null,"Subtotal for fixed expenses",null,null,null,null,{"$f":"SUM(G33:G51)","v":0},null,{"$f":"SUM(I33:I54)","v":0}]
[null,"ANR Event Services Planning Fee"," ",null,null,{"$f":"'A2. Estimated Expenses'!F47","v":0},null,null,{"$f":"H56","v":0}]
["Administrative/credit card fees","Administrative/credit card fees",null,null,null,null,{"$f":"+'A2. Estimated Expenses'!G48","v":0},null,{"$f":"('B3. Actual Income'!I17+'B3. Actual Income'!I28)*0.06","v":0}]
[null,"Sales Tax to be remitted",null,null,null,null,{"$f":"'A2. Estimated Expenses'!G49","v":0},null,{"$f":"(I30+(SUM(I33:I43)))*0.06","v":0}]
[null,"       Subtotal Out-of-Pocket Costs",null,null,null,null,{"$f":"G30+G55+G56+G58","v":0},null,{"$f":"I30+I55+I56+I57+I58","v":0}]
[null,null,null,null,null,null,null,null,null," "," "]
[]
[]
[null,"Summary of Personnel and Travel Costs (For Level 2 and 3 Events Only)"]
[null,null,null,null,null,null,null,null,null,"Budget","Actual"]
[null,"Personnel Salary/Benefits",null,null,null,null,null,null,null,{"$f":"IF('A1. Program Details'!C25>1,'A1. Program Details'!F41,\"\")","v":""},{"$f":"IF('B1. Actual Program Details '!C26>1, 'B1. Actual Program Details '!I42, 0)","v":0}]
[null,"Personnel Travel",null,null,null,null,null,null,null,{"$f":"IF('A1. Program Details'!C25>1,'A1. Program Details'!F51,\"\")","v":""},{"$f":"IF('B1. Actual Program Details '!C26>1,'B1. Actual Program Details '!J52,0)","v":0}]
[null,"Total Personnel/Travel Expenses",null,null,null,null,null,null,null,{"$f":"SUM(J65:J66)","v":0},{"$f":"SUM(K65:K66)","v":0}]
[]
[null,"Program/Service Expenses"]
[null,null,null,null,null,null,null,null,null,"Budget","Actual"]
[null,"Total Program/Service Expenses",null,null,null,null,null,null,null,{"$f":"G59+J67","v":0},{"$f":"I59+K67","v":0}]
[]
[]
[]
[]
[]
[]
[null,null,null,null," "]
[null,null,null,null,null,null," "]

{"sheet":"B3. Actual Income","index":7,"n_rows":36,"n_cols":13,"rows_kept":36,"cut":false,"hidden":false,"merged":[[31,1,31,6],[33,1,33,6],[21,4,21,6],[27,4,27,6],[22,2,22,3],[25,2,25,3],[26,2,26,3],[22,4,22,6],[25,4,25,6],[26,4,26,6],[23,2,23,3],[24,2,24,3],[23,4,23,6],[24,4,24,6],[37,1,37,6],[36,1,36,6],[2,1,2,8],[4,1,4,2],[4,3,4,5],[4,6,4,7],[4,8,4,9],[6,1,8,8],[11,9,11,14],[10,1,10,2],[27,2,27,3],[19,2,19,3],[20,2,20,3],[21,2,21,3],[19,4,19,6],[20,4,20,6]]}
[null," ",null,null,null," "]
[]
[null,{"$f":"\"Income for \"&('A1. Program Details'!$C$15)&\"\"","v":"Income for "}]
[]
[null,"B1. Actual Program Details",null,"B2. Actual Expenses",null,null,"B4. Actual Summary"]
[]
[null,"Instructions:  This worksheet is used to calculate program income after program has been held. Enter actual number of program participants as well as any sponsors or partner contribution. "]
[]
[]
[]
[null,"Registration Fees/Participant  Income",null,"Estimated Number of Participants","Estmated Fee per person","Actual Number of Participants","Actual Fee per person","Budgeted Income","Actual Income",null,null,null," "]
[null,"Registration Fees  ",null,{"$f":"'B1. Actual Program Details '!C24","v":0},null,{"$f":"'B1. Actual Program Details '!C25","v":0}]
[null,"   Early Registration",null,{"$f":"+'A3. Estimated Income'!E14","v":0},{"$f":"+'A3. Estimated Income'!F14","v":0},null,null,{"$f":"D13*E13","v":0},{"$f":"G13*F13","v":0}]
[null,"   Normal Registration",null,{"$f":"+'A3. Estimated Income'!E15","v":0},{"$f":"+'A3. Estimated Income'!F15","v":0},null,null,{"$f":"D14*E14","v":0},{"$f":"G14*F14","v":0}]
[null,"   Onsite Registration",null,{"$f":"+'A3. Estimated Income'!E16","v":0},{"$f":"+'A3. Estimated Income'!F16","v":0},null,null,0,0]
[null,"   Student Registration",null,{"$f":"+'A3. Estimated Income'!E18","v":0},{"$f":"+'A3. Estimated Income'!F18","v":0},null,null,0,0]
[null,"Total Registration Income",null,null,null,null,null,{"$f":"SUM(H13:H16)","v":0},{"$f":"SUM(I12:I16)","v":0},null,null," "]
[]
[]
[null,"Sponsorship/grant/donation/other incoming funds to offset expenses","Sponsor/partner name",null,"Indicate if sponsorship, donation or in-kind?",null,null,"Amount","Actual"]
[null,"Sponsor",{"$f":"'A3. Estimated Income'!C23:D23","v":0},null,{"$f":"'A3. Estimated Income'!E23:F23","v":0},null,null,{"$f":"'A3. Estimated Income'!G23","v":0}]
[null,"Sponsor",{"$f":"'A3. Estimated Income'!C24:D24","v":0},null,{"$f":"'A3. Estimated Income'!E24:F24","v":0},null,null,{"$f":"'A3. Estimated Income'!G24","v":0}]
[null,"Other Funds",{"$f":"'A3. Estimated Income'!C25:D25","v":0},null,{"$f":"'A3. Estimated Income'!E25:F25","v":0},null,null,{"$f":"'A3. Estimated Income'!G25","v":0}]
[null,"Other Funds",{"$f":"'A3. Estimated Income'!C26:D26","v":0},null,{"$f":"'A3. Estimated Income'!E26:F26","v":0},null,null,{"$f":"'A3. Estimated Income'!G26","v":0}]
[null,"Other Funds",{"$f":"'A3. Estimated Income'!C27:D27","v":0},null,{"$f":"'A3. Estimated Income'!E27:F27","v":0},null,null,{"$f":"'A3. Estimated Income'!G27","v":0}]
[null,"Other Funds",{"$f":"'A3. Estimated Income'!C26:D26","v":0},null,{"$f":"'A3. Estimated Income'!E26:F26","v":0},null,null,{"$f":"'A3. Estimated Income'!G26","v":0}]
[null,"Other donation",{"$f":"'A3. Estimated Income'!C29:D29","v":0},null,{"$f":"'A3. Estimated Income'!E29:F29","v":0},null,null,{"$f":"'A3. Estimated Income'!G29","v":0}]
[null,"Total sponsorship/grant/donation",null,null," ",null,null,{"$f":"SUM(H21:H27)","v":0},{"$f":"SUM(I21:I27)","v":0}]
[]
[]
[]
[null,"Actual Total Registration Income",null,null,null,null,null,{"$f":"H17","v":0},{"$f":"I17","v":0}]
[]
[null,"Actual Total Sponsorship/Grant/Donation Income",null,null,null,null,null,{"$f":"H28","v":0},{"$f":"I28","v":0}]
[]
[null,"Total Program Income",null,null,null,null,null,{"$f":"H32+H34","v":0},{"$f":"I32+I34","v":0}]

{"sheet":"B4. Actual Summary","index":8,"n_rows":39,"n_cols":11,"rows_kept":39,"cut":false,"hidden":false,"merged":[[2,1,2,6],[9,2,9,3],[24,2,24,3],[14,1,14,3],[12,1,12,3],[13,1,13,3],[16,1,16,3],[22,1,22,3],[4,2,4,3],[4,4,4,5],[6,1,6,6],[11,1,11,3],[8,2,8,3],[17,1,17,3],[18,1,18,3],[25,2,25,3],[29,1,29,4],[30,2,30,4],[27,2,27,3]]}
[null," ",null,null," "]
[]
[null,{"$f":"\"Actual Summary for \"&('A1. Program Details'!$C$15)&\"\"","v":"Actual Summary for "}]
[]
[null,"B1. Actual Program Details","B2. Actual Expenses",null,"B3. Actual Income"]
[]
[null,"Instructions:  This page summarizes actual income and expenses for the program. Any costs recovered are split according to the values entered in the shaded cells below. Losses are split according to each party's percent of expenses."]
[]
[null," Income ",null,null,"Estimated","Actual"]
[null,"Income from participant fee",null,null,{"$f":"'A4. Estimated Summary'!E11","v":0},{"$f":"+'B3. Actual Income'!I17","v":0}]
[]
[null,"Expense (broken down by cost per Participant)",null,null,"Estimated","Actual"]
[null,"Variable Cost  ",null,null,{"$f":"'A4. Estimated Summary'!E14","v":false},{"$f":"IF('B1. Actual Program Details '!C25>0,'B2. Actual Expenses  '!I30/'B1. Actual Program Details '!C25)","v":false}]
[null,"Fixed Cost ",null,null,{"$f":"'A4. Estimated Summary'!E15","v":false},{"$f":"IF('B1. Actual Program Details '!C25>0,'B2. Actual Expenses  '!I55/'B1. Actual Program Details '!C25)","v":false}]
[null,"Event management fee, Admin & Credit Card Fees ",null,null,{"$f":"'A4. Estimated Summary'!E16","v":false},{"$f":"IF('B1. Actual Program Details '!C25>0,('B2. Actual Expenses  '!I56+'B2. Actual Expenses  '!I57)/'B1. Actual Program Details '!C25)","v":false}]
[null,"Sales Tax ",null,null,{"$f":"'A4. Estimated Summary'!E17","v":false},{"$f":"IF('B1. Actual Program Details '!C25>0,'B2. Actual Expenses  '!I58/'B1. Actual Program Details '!C25)","v":false}]
[null,"Program related personnel and travel",null,null,{"$f":"'A4. Estimated Summary'!E18","v":false},{"$f":"IF('B1. Actual Program Details '!C25>0,'B2. Actual Expenses  '!K67/'B1. Actual Program Details '!C25)","v":false}]
[null,"Total cost per participant",null,null,{"$f":"'A4. Estimated Summary'!E19","v":false},{"$f":"IF('B1. Actual Program Details '!C25>0,'B2. Actual Expenses  '!K71/'B1. Actual Program Details '!C25)","v":false}]
[null,"Total expense of running program",null,null,{"$f":"'A4. Estimated Summary'!E20","v":0},{"$f":"F18*'B1. Actual Program Details '!C25","v":0}]
[]
[null,"Net Income (not Including Sponsorships)",null,null,{"$f":"E10-E19","v":0},{"$f":"F10-F19","v":0}]
[]
[null,"Sponsorship/donation/grant given to program/service",null,null,{"$f":"'A4. Estimated Summary'!E24","v":0},{"$f":"'B3. Actual Income'!I28","v":0}]
[]
[null,"Net Profit/LossTotal cost",null,null,{"$f":"E10-E19+E23","v":0},{"$f":"F10-F19+F23","v":0}]
[null,"Cost per Participant ",null,null,{"$f":"E25/'B1. Actual Program Details '!C24","v":{"$error":"#DIV/0!"}},{"$f":"F25/'B1. Actual Program Details '!C24","v":{"$error":"#DIV/0!"}}]
[]
[null,"Taxable Amount per Person ",null,null,{"$f":"'A4. Estimated Summary'!E29","v":false},{"$f":"IF('B1. Actual Program Details '!C25>0,('B2. Actual Expenses  '!I30+'B2. Actual Expenses  '!I33+'B2. Actual Expenses  '!I34+'B2. Actual Expenses  '!I35+'B2. Actual Expenses  '!I36+'B2. Actual Expenses  '!I37+'B2. Actual Expenses  '!I38+'B2. Actual Expenses  '!I39+'B2. Actual Expenses  '!I40+'B2. Actual Expenses  '!I41+'B2. Actual Expenses  '!I42+'B2. Actual Expenses  '!I43)/'B1. Actual Program Details '!C25,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null," "]
[null,"Cost Recovery - This portion is required. "]
[null,"Contact for the Financial Aspects for the Event:"]
[null,"Option 1 - Groups","Amount ","Acct Number","Name"]
[null,"Work Group  (50 percent)",{"$f":"IF('A1. Program Details'!C27>1,'A4. Estimated Summary'!E26*0.5,0)","v":0}]
[null,"Institute (50 percent)",{"$f":"IF('A1. Program Details'!C27>1,'A4. Estimated Summary'!E26*0.5,0)","v":0}]
[]
[null,"Option 2 - Individual","Amount ","Acct Number","Name"]
[null,"Work Group (30 percent)",{"$f":"IF('A1. Program Details'!C27=1,'A4. Estimated Summary'!E26*0.3,0)","v":0}]
[null,"Institute (30 percent)",{"$f":"IF('A1. Program Details'!C27=1,'A4. Estimated Summary'!E26*0.3,0)","v":0}]
[null,"Individual (40 percent)",{"$f":"IF('A1. Program Details'!C27=1,'A4. Estimated Summary'!E26*0.4,0)","v":0}]